package com.yxy.model;


import lombok.Data;
import tk.mybatis.mapper.annotation.KeySql;
import tk.mybatis.mapper.code.ORDER;

import java.util.Date;
import java.math.BigDecimal;

import javax.persistence.*;


@Data
@Entity
@Table(name = "table_product",schema = "")
public class TableProduct {

  //id
  @Id
  @KeySql(useGeneratedKeys = true,sql = "SELECT @@IDENTITY",order = ORDER.AFTER)
  @Column(name = "id")
  private Long id;

  //产品编码
  @Column(name = "pro_code")
  private String proCode;

  //产品名称
  @Column(name = "pro_name")
  private String proName;

  //产品价格
  @Column(name = "pro_price")
  private BigDecimal proPrice;

  //产品时间
  @Column(name = "pro_time")
  private Date proTime;

  //产品类型
  @Column(name = "pro_type_code")
  private String proTypeCode;

  //产品类型名称
  @Column(name = "pro_type_name")
  private String proTypeName;

  //产品详细描述
  @Column(name = "pro_desc")
  private String proDesc;


  //产品简要描述
  @Column(name = "pro_brief")
  private String proBrief;

  //产品品牌
  @Column(name = "pro_brand")
  private String proBrand;

  //产品产地
  @Column(name = "pro_place")
  private String proPlace;

  //产品厂家
  @Column(name = "pro_people")
  private String proPeople;

  //产品图片路径
  @Column(name = "pro_url")
  private String proUrl;

  //产品图片名称
  @Column(name = "pro_file_name")
  private String proFileName;

  //产品库存
  @Column(name = "pro_inventory")
  private Long proInventory;

  //产品销量
  @Column(name = "pro_sale")
  private Long proSale;


  //标记数据状态 0 不显示 1显示
  @Column(name = "status")
  private Long status;

  //数据备注
  @Column(name = "misc")
  private String misc;

  //创建者id
  @Column(name = "create_user_id")
  private Long createUserId;

  //创建人姓名
  @Column(name = "create_user_name")
  private String createUserName;

  //创建时间
  @Column(name = "create_date")
  private Date createDate;

  //修改人id
  @Column(name = "update_user_id")
  private Long updateUserId;

  //修改人姓名
  @Column(name = "update_user_name")
  private String updateUserName;

  //更新时间
  @Column(name = "update_date")
  private Date updateDate;

  //varchar预留字段1
  @Column(name = "param1")
  private String param1;

  //规格
  @Column(name = "pro_unit")
  private String proUnit;

  //预留字段2
  @Column(name = "param2")
  private Long param2;

  //预留字段3
  @Column(name = "param3")
  private BigDecimal param3;


}
